﻿/****** Script for SelectTopNRows command from SSMS  ******/
CREATE VIEW [ODCore].[MethodProperty_View]
AS
SELECT     MP.MethodID, M.MethodName, G.PropertyName, MP.PropertyValue, U.UnitAbbreviation
FROM         [ODExtensibility].[MethodProperty] AS MP INNER JOIN
                      [ODExtensibility].[GenericProperty] AS G ON G.PropertyID = MP.PropertyID INNER JOIN
                      [ODCore].[Unit] AS U ON U.UnitID = MP.PropertyUnitID INNER JOIN
                      [ODCore].[Method]  AS M ON M.MethodID = MP.MethodID
